Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
BusinessUnitChannelID (PK) | A token ID that defines the kind of channel a BusinessUnit may use to conduct business with its partners. | ID_BSN_UN_CHNL | Identity | integer | |
ChannelID (FK)(PK) | Token Identifier for a channel instance | ID_CHNL | Identity | integer | Channel(CO_CHNL) |
EffectiveDate | The date a business unit channel is able to operate. | DT_EF | DateTime | datetime | |
ExpirationDate | The date a BusinessUnitChannel may no longer operate | DT_EP | DateTime | datetime | |
StatusCode | The current status (or state) of a BusinessUnitChannel. Indicates if the combination is active or inactive. | SC_BSN_UN_CHNL | Code2Status | char(2) | |
BusinessUnitGroupID (FK) | A unique system assigned identifier for a group of BusinessUnits. | ID_BSNGP | Identity | integer | BusinessUnitGroup(CO_BSNGP) |
RetalierWebSiteName | The Retailer Web Site name. This attribute is a placeholder and will be replaced with a FK reference to the retailer's web site in future releases of the ODM. For now we are treating this as an owned attribute. | NM_WB_STE | DescriptionShort | integer | |